Here is a comprehensive summary in English of the presentation titled **“Geodatabases and Coordinate Systems”** by Thomas Bauer & Franz Suppan (University of Natural Resources and Life Sciences Vienna).

This is Part 2.1 of the Geodata Management Course.

---

### **1. Introduction to Earth Representation and Coordinate Systems**

* The Earth’s shape is represented mathematically to facilitate mapping and spatial analysis.
* Common references include:

  * **Plane**: Horizontal approximation.
  * **Sphere**: Simplified model with a radius (\~6370 km).
  * **Ellipsoid**: More accurate, accounts for Earth's flattening (e.g., WGS84, GRS80).
  * **Reference Ellipsoid**: Best fit to the geoid in a specific region (e.g., Bessel Ellipsoid in Austria).
* **Geoid**: A physical model representing sea level, used for precise height measurements.

---

### **2. Geodetic Datum and Coordinate Systems**

* A **geodetic datum** defines the position of the coordinate system relative to the geoid (e.g., WGS84, MGI).
* Coordinate systems include:

  * **Geographic** (latitude/longitude),
  * **Cartesian**,
  * **Ellipsoidal** (f, λ, h).
* **Transformations** (e.g., 7-parameter) convert coordinates between datums.

---

### **3. Map Projections**

* **Map projections** convert 3D Earth coordinates to 2D map coordinates.
* Types:

  * **Azimuthal**, **Cylindrical**, **Conic**.
  * Classified by properties:

    * **Conformal**: preserves angles,
    * **Equidistant**: preserves distances,
    * **Equal-area**: preserves area.
* **Projection positions**: normal, transverse, oblique.

---

### **4. Common Projections in Austria and Europe**

* **Gauß-Krüger (GK)**:

  * Cylindrical, transverse, conformal.
  * EPSG codes vary based on the meridian used (Ferro or Greenwich).
* **Bundesmeldenetz (BMN)**:

  * Modified GK with false eastings/northings.
* **UTM (Universal Transverse Mercator)**:

  * Zonal system, each 6° wide.
  * EPSG codes: e.g., 32632, 25833.
* **Lambert Azimuthal Equal-Area (LAEA)**:

  * Used for European-wide spatial analysis (EPSG: 3035).
* **WGS 84 / Pseudo-Mercator**:

  * Web mapping standard (EPSG: 3857).

---

### **5. Height Measurement**

* **Geodetic height (h)**: GNSS-measured, above ellipsoid.
* **Orthometric height (H)**: Above sea level.
* **Geoid undulation (N)**: h - H.
* Accuracy depends on the datum and local anomalies.

---

### **6. Coordinate Reference System (CRS)**

* A CRS includes:

  * **Datum**: ellipsoid, axis, center.
  * **Projection**: type, scale, false coordinates.
  * **EPSG code**: unique ID (e.g., EPSG: 31256 for Austria GK East).
* Tools: [epsg.org](https://epsg.org), [spatialreference.org](https://spatialreference.org).

---

### **7. CRS in QGIS**

* QGIS supports:

  * **Geographic systems**: MGI, WGS84, ETRS89.
  * **Projected systems**: UTM, GK, BMN.
  * **User-defined CRS**.
* CRS management:

  * Automatic transformation if the same datum is used.
  * Manual selection for different datums.
  * Projects default to EPSG:4326 unless overridden.

---

### **8. High Accuracy Geo-Transformation in QGIS**

* Transformations from AMA export files can vary in accuracy:

  * 3-parameter: \~106m deviation.
  * 7-parameter: \~1.5m.
  * **BEV Grid / NTv2**: \~0.15m (raster-based interpolation).
* Setup requires downloading the NTv2 grid (`AT_GIS_GRID.gsb`) and installing plugins in QGIS.

---

### **9. Data, Software, and Hardware Lifespans**

* Hardware: 3–5 years.
* Software: 5–10 years.
* Data can have longer lifespans, depending on quality and use.

---

### **10. GIS Databases and Formats**

* Databases replace classic file systems:

  * **PostgreSQL/PostGIS**, **SpatialLite**, **SQLite/GeoPackage**, **Oracle Spatial**, **Microsoft SQL Spatial**.
* Vector formats:

  * **Shape-File**: Most common; multiple components (.shp, .dbf, .shx, .prj, etc.).
* **GeoPackage (GPKG)** and **SpatiaLite**: SQLite-based formats; future alternatives to shapefiles.

---

### **Conclusion**

The presentation covers the fundamental concepts of representing the Earth for spatial analysis, including coordinate systems, map projections, datums, and data handling in GIS—particularly using QGIS. It emphasizes the importance of correct CRS use and accurate transformation methods for reliable geospatial data management and mapping.

---

Let me know if you want a visual mind map or a summarized version for a specific topic (e.g., map projections or QGIS usage).
